l104/opdrachten in de les/auteurdetail.php

<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Document</title> </head> <body> <?php include ('../db.php'); $auteurnr = $_GET['auteurnr']; $query = "SELECT * FROM auteurs a where a.auteurnr = $auteurnr "; $result = mysqli_query($db, $query) or die ('Error: ' . $query); $row = mysqli_fetch_assoc($result); echo "<h1>$row[voornaam] ($row[voorletters]) $row[tussenvoegsel] $row[achternaam]</h1>"; echo "<div>$row[geb_jaar] - $row[sterfjaar]</div>"; echo "<br>"; echo "<div>Auteurnummer: $row[auteurnr]</div>"; echo "<br>"; echo "<h3>Geschreven boeken</h3>"; $query = "SELECT * FROM boeken b where b.auteurnr = $auteurnr"; $result = mysqli_query($db, $query) or die ('Error: ' . mysqli_error($db)); echo "<table>"; echo '<tr>'; echo '<th>Titel</th>'; echo '</tr>'; while ($row = mysqli_fetch_assoc($result)){ echo "<tr><td><a href='boekdetail.php?boeknr=$row[boeknr]'>$row[titel]</a></td></tr>\n"; } echo "</table>"; ?> </body> </html>

Resultaat

Made by Thijs Aarnoudse